devgram
Tables (23)
Board (Untitled4)
- board_seq (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- status (Field7)
- created_at (Field3)
- updated_at (Field5)
- like_count (Field4)
- tag_seq (Key2) — Foreign key → Tag.tag_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
- updated_by (Key42) — Foreign key → User.user_seq — NOT NULL
Board_Accuse (Untitled17)
- Board_Accuse_Seq (Key) — Primary key — NOT NULL
- content (Field)
- report_at (Field2)
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- reporter (Key4) — Foreign key → User.user_seq — NOT NULL
Board_Image (Untitled11)
- board_image_seq (Key) — Primary key — NOT NULL
- name (Field)
- path (Field2)
- created_at (Field3)
- updated_at (Field4)
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
- updated_by (Key42) — Foreign key → User.user_seq — NOT NULL
Board_Log (Untitled10)
- board_log_seq (Key) — Primary key — NOT NULL
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- before_content (Field)
Board_Product (Untitled18)
- Board_Product_Seq (Key) — Primary key — NOT NULL
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- product_seq (Key3) — Foreign key → Product.product_seq — NOT NULL
- order (Field)
Board_Tag (Untitled19)
- Board_Tag_seq (Key) — Primary key — NOT NULL
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- tag_seq (Key3) — Foreign key → Tag.tag_seq — NOT NULL
- order (Field)
Board_like (Untitled16)
- board_like_seq (Key) — Primary key — NOT NULL
- user_seq (Key4) — Foreign key → User.user_seq — NOT NULL
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
Category (Untitled5)
- category_seq (Key) — Primary key — NOT NULL
- name (Field) — UNIQUE
- color (Field2) — UNIQUE
Chat (Untitled21)
- Key — Primary key — NOT NULL
- contents (field)
- created_at (Field2)
- chatroom_seq (Key2) — Foreign key → Chatroom.chatroom_seq — NOT NULL
Chatroom (Untitled20)
- chatroom_seq (Key) — Primary key — NOT NULL
- name (Field)
Chatroom_paricipant (Untitled22)
- chatroom_participant_seq (Key) — Primary key — NOT NULL
- chatroom_seq (Key2) — Foreign key → Chatroom.chatroom_seq — NOT NULL
- user_seq (Key4) — Foreign key → User.user_seq — NOT NULL
Follow (Untitled6)
- follow_Seq (Key) — Primary key — NOT NULL
- follow (Key4) — Foreign key → User.user_seq — NOT NULL
- follower (Key42) — Foreign key → User.user_seq — NOT NULL
Product (Untitled2)
- product_seq (Key) — Primary key — NOT NULL
- title (Field2)
- content (Field3)
- hits (Field4)
- rating (Field5)
- like_count (Field6)
- price (Field)
- category_seq (Key2) — Foreign key → Category.category_seq — NOT NULL
Product_Image (Untitled12)
- product_image_seq (Key) — Primary key — NOT NULL
- name (Field)
- path (Field2)
- creaetd_at (Field3)
- updated_at (Field4)
- product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
- updated_by (Key42) — Foreign key → User.user_seq — NOT NULL
Product_Like (찜)
- product_like_seq (Key) — Primary key — NOT NULL
- user_seq (Key4) — Foreign key → User.user_seq — NOT NULL
- product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL
Review (Untitled3)
- review_seq (Key) — Primary key — NOT NULL
- mark (Field)
- content (Field4)
- status (Field5)
- creaetd_at (Field2)
- product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
Review_Accuse (Untitled15)
- Key — Primary key — NOT NULL
- content (Field2)
- report_at (Field3)
- review_seq (Key2) — Foreign key → Review.review_seq — NOT NULL
- reporter (Key4) — Foreign key → User.user_seq — NOT NULL
Review_Image (Untitled13)
- review_image_seq (Key) — Primary key — NOT NULL
- name (Field)
- path (Field2)
- created_at (Field3)
- updated_at (Field4)
- review_seq (Key2) — Foreign key → Review.review_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
- updated_by (Key42) — Foreign key → User.user_seq — NOT NULL
Tag (Untitled7)
- tag_seq (Key) — Primary key — NOT NULL
- name (Field) — UNIQUE
- use_count (Field2)
USER_Image (Untitled8)
- file_seq (Key) — Primary key — NOT NULL
- user_seq (Key42) — Foreign key → User.user_seq — NOT NULL
- name (Field)
- path (Field2)
- created_at (Field4)
- updated_at (Field3)
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
- updated_by (Key43) — Foreign key → User.user_seq — NOT NULL
User (Untitled)
- user_seq (Key4) — Primary key — NOT NULL
- name (Field2)
- password (Field3)
- email (Field4) — UNIQUE
- status (Field5)
- role (Field6)
- annual (Field)
- job (Field11)
- follow_count (Field12)
- follower_count (Field13)
- created_at (Field7)
- created_by (Field8)
- updated_at (Field9)
- updated_by (Field10)
comment (Untitled9)
- comment_seq (Key) — Primary key — NOT NULL
- content (Field)
- status (Field2)
- created_at (Field3)
- parent_comment_seq (Key3) — Foreign key → comment.comment_seq — NOT NULL
- board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
- created_by (Key4) — Foreign key → User.user_seq — NOT NULL
comment_Accuse (Untitled14)
- comment_accuse_Seq (Key) — Primary key — NOT NULL
- content (Field2)
- report_at (Field3)
- comment_seq (Key2) — Foreign key → comment.comment_seq — NOT NULL
- user_seq (Key4) — Foreign key → User.user_seq — NOT NULL