sceanestagram
Tables (14)
chat
- idx — number — Primary key — NOT NULL
- room_idx — number — Foreign key → chat_room.idx — NOT NULL
- writer_idx — number — NOT NULL
- content — varchar2(500)
- regist_date — date
- status — varchar2(10)
chat_room
- idx — number — Primary key — NOT NULL
- participant1_idx — number — Foreign key → users.idx — NOT NULL
- participant2_idx — number — Foreign key → users.idx — NOT NULL
- regist_date — date
- status — varchar2(10)
comments
- idx — number — Primary key — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
- parent_idx — number
- depth — number
- content — varchar(3000) — NOT NULL
- regist_date — date
- status — varchar2(10)
comments_hashtag
- idx — number — Primary key — NOT NULL
- comments_idx — number — Foreign key → comments.idx — NOT NULL
- hashtag_idx — number — Foreign key → hashtag.idx — NOT NULL
comments_users_like
- idx — number — Primary key — NOT NULL
- comments_idx — number — Foreign key → comments.idx — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
comments_users_tag
- idx — number — Primary key — NOT NULL
- comments_idx — number — Foreign key → comments.idx — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
follow
- idx — number — Primary key — NOT NULL
- follower_idx — number — Foreign key → users.idx — NOT NULL
- following_idx — number — Foreign key → users.idx — NOT NULL
hashtag
- idx — number — Primary key — NOT NULL
- hashtag — varchar2(300) — NOT NULL
image
- idx — number — Primary key — NOT NULL
- file_name — varchar2(300) — NOT NULL
post
- idx — number — Primary key — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
- content — varchar2(3000)
- location — varchar2(300)
- regist_date — date
- status — varchar2(10)
- views — number
post_hashtag
- idx — number — Primary key — NOT NULL
- hashtag_idx — number — Foreign key → hashtag.idx — NOT NULL
post_users_like
- idx — number — Primary key — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
post_users_tag
- idx — number — Primary key — NOT NULL
- users_idx — number — Foreign key → users.idx — NOT NULL
users
- idx — number — Primary key — NOT NULL
- email — varchar2(500) — NOT NULL
- pw — varchar2(2000) — NOT NULL
- gender — varchar2(10)
- 여성)) — NOT — NOT NULL
- birth — date — NOT NULL
- phone_number — varchar2(100) — NOT NULL
- name — varchar2(100) — NOT NULL
- nick_name — varchar2(100) — NOT NULL
- introduce — varchar2(150 char)
- user_img — varchar2(300)
- join_date — date
- status — varchar2(10)