JapaneseSnsWeb
Tables (8)
CONTENT
- content_id — Primary key
- writer_id — INT — Foreign key → Group.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- content
- modified_at
- created_at
DM
- dm_id — INT — Primary key — NOT NULL
- chatroom_id — INT — Foreign key → chatroom.chatroom_id — NOT NULL
- participant_id — INT — Foreign key → Group.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- modified_at
- created_at
FLLOW
- fllow_id — Primary key — NOT NULL
- following_id (user_id) — INT — Foreign key → Group.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- follower_id — INT — Foreign key → Group.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- modified_at
- created_at
Group
- id (user_id) — INT — Primary key — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- group_name — NOT NULL
- password
- profileImageUrl (profile_image_url)
- role
- createAt (create_at)
- modifiedAt (modified_at)
MEDIA
- media_id — Primary key — NOT NULL
- content_id — Foreign key → CONTENT.content_id
- file_name
- created_at
REPLY
- reply_id — Primary key — NOT NULL
- content_id — Foreign key → CONTENT.content_id
- writer_id — INT — Foreign key → Group.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
- reply
- modified_at
- created_at
User (user)
- Key — Primary key — NOT NULL
chatroom (Untitled)
- chatroom_id — INT — Primary key — NOT NULL
- last_particpant_name
- last_message
- modified_at
- created_at